1001 Secrets for Windows NT Registry
(Publisher: 29th Street Press)
Author(s): Tim Daniels
ISBN: 1882419685
Publication Date: 12/01/97

Previous Table of Contents Next


Simply add the values of the options you want. The final value is their sum. For example, if you wanted just the Border and Font options, add 8 and 2 for a value of 10.

IV-35 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Recent File List
Value Name: File1 or File2 or File3, etc.
Data Type: REG_SZ
Value: <last used file>

These values show the most recently used files that appear on the bottom of the File menu.

IV-36 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: Basics
Data Type: REG_DWORD
Value: 1

If this value is set to 0, Microsoft Excel starts up with the Office Assistant, which displays a menu that lets you see key information. After you click “Start using Microsoft Excel,” Excel sets this value to 1, thereby disabling this function. If you want to go back and learn about the new features, set this value to 0.

IV-37 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: AddIn Path
Data Type: REG_SZ
Value: <paths of add-on programs>

In this value, you tell Excel the directories to search in for add-on programs and tools. Separate multiple paths with semicolons (;).

IV-38 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: AltStartup
Data Type: REG_SZ
Value: <path of alternate startup folder>

This value specifies the location of the alternate startup folder. Microsoft Excel automatically loads files from this directory after loading files from the Xlstart folder.

IV-39 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: 3dDialogs
Data Type: REG_DWORD
Value: 0x1

This value tells Microsoft Excel to use 3-D dialog boxes. If you prefer the look of regular dialog boxes, set this value to 0.

IV-40 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: AutoCalculate
Data Type: REG_DWORD
Value: <index value>

This value sets the AutoCalculation function. Your options are

0 Count Nums
4 Sum
5 Average
6 Min
7 Max
169 Count

IV-41 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: User
Data Type: REG_SZ
Value: <user name>

This value is the user name that Microsoft Excel attaches to Workbooks.

IV-42 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: CfDDELink
Data Type: REG_SZ
Value: 1

If this value is set to 1, Microsoft Excel remembers the last clipboard format used for a successful DDE operation. Setting this option helps reduce the time required for future DDE operations.


Previous Table of Contents Next